SQL Excel Concatenate into INSERT Command


=CONCATENATE("    ('",A2,"', '",B2,"', '",C2,"', '",D2,"', '",E2,"',", 
      "'" ,F2, "',",
      "'" ,G2, "',",
      "'" ,H2, "',",
      "'" ,I2, "',",
      "'" ,J2, "',",
      "'" ,K2, "',",
      "'" ,L2, "',",
      "'" ,M2, "',",
      "'" ,N2, "',",
      "'" ,O2, "',",
      "'" ,P2, "',",
      "'" ,Q2, "',",
      "'" ,R2, "',",
      "'" ,S2, "'",

      ")")
#SQL






你可能感興趣的文章

滲透測試重新打底(3.1)--論Web入侵之Burp Suite基本使用

滲透測試重新打底(3.1)--論Web入侵之Burp Suite基本使用

AWS Solutions Architect - Associate (SAA) 學習計畫與備考心得: Module 8

AWS Solutions Architect - Associate (SAA) 學習計畫與備考心得: Module 8

[ 筆記 ] HTML - tag 基礎標籤

[ 筆記 ] HTML - tag 基礎標籤






留言討論